Import and analyze data

Overview of Excel tables

Create and format tables

Copy a Word table into Excel

Format an Excel table

Resize a table by adding or removing rows and columns

Use calculated columns in an Excel table

Total the data in an Excel table

Sort data in a range or table

Filter data in a range or table

Filter for unique values or remove duplicate values

Available chart types in Office

Create a chart

Add a pie chart

Present your data in a Gantt chart

Create a waterfall chart in Office 2016

Create a histogram

Change axis labels in a chart

Select data for a chart

Add axis titles to a chart

Add a trend or moving average line to a chart 

Create a PivotTable to analyze worksheet data

Use multiple tables to create a PivotTable

Calculate values in a PivotTable

Format PivotTables by using the Field List to arrange fields

Change the source data for a PivotTable

Delete a PivotTable

Create dynamic charts by using PivotCharts

Filter data in a PivotTable

Create a PivotTable timeline to filter dates

Create a data model in Excel

Import Data into Excel and Create a Data Model

Power Pivot Overview and Learning

Delete relationships between tables in a Data Model

Measures in Power Pivot

Data Model specification and limits

Add worksheet data to a Data Model using a linked table 

Data Analysis Expressions DAX in Power Pivot​​​​​​​